UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O7gmyNeCZRa9ThPFtxa25ALmKVQf2fPFU9fdSWQGd48='
WHERE
key_id = '828dce07917dd22e72fa6f71da30f001a184cdb18d1394c1bb55b94e28275d1d'
AND (
token = 'O7gmyNeCZRa9ThPFtxa25ALmKVQf2fPFU9fdSWQGd48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)