UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f8CprEbnJTcvBnPaJPZ3IoiD45ckTsWhJ8SdXSxj7k8='
WHERE
key_id = '69a0b39fae7eb8a04373c8a9ca573ab7b953f40b9832ca9e3b92925cdf226fe2'
AND (
token = 'f8CprEbnJTcvBnPaJPZ3IoiD45ckTsWhJ8SdXSxj7k8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)