UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JcLfevjG5VWLi7fz08K2HNLQwSNJvTyq6yYhoCGeEp8='
WHERE
key_id = '77bab7a2e204ec6691e28da52476136f5e987779aaa4fc8c96dd9f973e241413'
AND (
token = 'JcLfevjG5VWLi7fz08K2HNLQwSNJvTyq6yYhoCGeEp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)