UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfOCcaXPuREXdfhB5dYrVgUIUO9vRqI0gSeodaeV9No='
WHERE
key_id = '4f4ab67e9c1a5dcb729a4237adc3a65145c85b7e2983e6b13987b6d922de1b99'
AND (
token = 'xfOCcaXPuREXdfhB5dYrVgUIUO9vRqI0gSeodaeV9No='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)