UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQgBjVSRn7mm2016nu6labdE44l/KiC10RMl9w7wOCY='
WHERE
key_id = '2372f7c084f545b6f1207b24bbb666999dd31977069760b960f8da19fa4ef073'
AND (
token = 'CQgBjVSRn7mm2016nu6labdE44l/KiC10RMl9w7wOCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)