UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQLK6f+QwQudg/VA5FZ4JW/g/11wockuT+nE7y4VkUM='
WHERE
key_id = 'b66496f3dcc86906c587fb00ceb7f97ee7763af53c24994a5a8e7117ce7804de'
AND (
token = 'lQLK6f+QwQudg/VA5FZ4JW/g/11wockuT+nE7y4VkUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)