UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F7erVfguY2jg+4fqY/dM3bLXBeY21Tynh78QSIYZuZM='
WHERE
key_id = 'c7e5e5f52e8de0a386b414acfe630c3dcf4979e611118f0ed1fb8453a4023f51'
AND (
token = 'F7erVfguY2jg+4fqY/dM3bLXBeY21Tynh78QSIYZuZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)