UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25nHiKbdRH9jWWphEvDG75pyLGpoH5L60YJfg7UIYZ4='
WHERE
key_id = 'f2c3ee698c2d6e5ad4d8d28895b14843cb512d840c66e4e30fec3973259cc29f'
AND (
token = '25nHiKbdRH9jWWphEvDG75pyLGpoH5L60YJfg7UIYZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)