UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eQ7vlYmg1I3TWyGailZ/GNrsZ1FC9ocvARRdt+Stv/E='
WHERE
key_id = 'a73dea432dcd9365f84db71f7edbc17a4e0c390cbbceb970e928defe99ab6f9a'
AND (
token = 'eQ7vlYmg1I3TWyGailZ/GNrsZ1FC9ocvARRdt+Stv/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)