UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VkpKnKnWX9kqaku/fgAZSY1WQ8RlWnwiWt6Y+nWh58M='
WHERE
key_id = 'a2ae8823e243f6e2e21842c15545524b162bedec70d530955252c789c0248913'
AND (
token = 'VkpKnKnWX9kqaku/fgAZSY1WQ8RlWnwiWt6Y+nWh58M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)