UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O6lfUnBJ9KUVKspefp2822xwIYNpa6tjTl9EMSsC+Bo='
WHERE
key_id = 'a669ce49d753639e1f2f9503eb96906545e69decaeb9ad424ad1c97fe987e994'
AND (
token = 'O6lfUnBJ9KUVKspefp2822xwIYNpa6tjTl9EMSsC+Bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)