UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcYLShAUcpMyMQdStnqewzJ7GE/xgnIWvZr6LiiM3PI='
WHERE
key_id = '1add86e5c9761d110f364e159d54b11ce8eacb0cb04ee7890a8a50bed61ad3d0'
AND (
token = 'XcYLShAUcpMyMQdStnqewzJ7GE/xgnIWvZr6LiiM3PI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)