UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gTgOj1FdWQJf4u99hfmJ3lRoqBXr0Bns+SjnWe8HYFo='
WHERE
key_id = '6ac1a3b01359ba1e931dca92bc734a3c48d7f7a291ce7be37c5a25a8dc8cfdbc'
AND (
token = 'gTgOj1FdWQJf4u99hfmJ3lRoqBXr0Bns+SjnWe8HYFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)