UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oegp006cRs65ZZIbQlB8STPjN0KwwKC/BxYMOlSYonw='
WHERE
key_id = 'b99634651518225dadc35e5a96c997d3e3ae864613b01e71c6921212ff8a2148'
AND (
token = 'oegp006cRs65ZZIbQlB8STPjN0KwwKC/BxYMOlSYonw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)