UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MrN8Q9kZoFAaO0htb2gzJ4IVE5bO48dITARPO973lm8='
WHERE
key_id = '6ce7a0c3437b6fc3f634493f9d16929dafdb363b105d42b2a588ee1657b65165'
AND (
token = 'MrN8Q9kZoFAaO0htb2gzJ4IVE5bO48dITARPO973lm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)