UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YOrvJMrfaH7F6rEfi6O0zqtQ0WaqSwXj1n7IyZpdD4M='
WHERE
key_id = 'eee4b0778a6e6746b7a2afb93a0ef34cea5276cc7d9dc07e0c99f0cba1c2bfea'
AND (
token = 'YOrvJMrfaH7F6rEfi6O0zqtQ0WaqSwXj1n7IyZpdD4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)