UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JfISpfcsrq7b8M3hcDS2AiP6LsgaWO14znlvG+EW53s='
WHERE
key_id = '07f47d1b23b4e046b07baf66e9623c40a20a1ffab2059c49e9c79dc01b7b6a2a'
AND (
token = 'JfISpfcsrq7b8M3hcDS2AiP6LsgaWO14znlvG+EW53s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)