UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qAbxnr34nOeZckts6dU8+RE2uYuG00Vho7UHcx9rLOs='
WHERE
key_id = '9ef1f02ee11c45a598bdd92e47968fc7d4a40b4f9a1638e9c4239cc6ea41aa94'
AND (
token = 'qAbxnr34nOeZckts6dU8+RE2uYuG00Vho7UHcx9rLOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)