UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NLvHCnB/L+FK6WwveWOa2r0ViGojOKXdi9VQ4eaAxM='
WHERE
key_id = 'd9af75f6e78f92439489d51df0d4cca88c13f738453fcf67ab80fe951e7e59a1'
AND (
token = '2NLvHCnB/L+FK6WwveWOa2r0ViGojOKXdi9VQ4eaAxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)