UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/g73maSgYtuE7T1v7tbl5sa/Acjg/zzbwIJ64/Vwng='
WHERE
key_id = 'cf686cfb560032f83aaa10b26116d42a96f98256f90faf9fee9f013334a560bd'
AND (
token = 'X/g73maSgYtuE7T1v7tbl5sa/Acjg/zzbwIJ64/Vwng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)