UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lmQUejuD911CCKb6fpejcMlC1iAr2j37YZYOj4xlgs8='
WHERE
key_id = '31da36ba47e38c13c790f6288d51b5c20786118c2f4c27485b5e7a4e52ff7a98'
AND (
token = 'lmQUejuD911CCKb6fpejcMlC1iAr2j37YZYOj4xlgs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)