UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SkLO/AMNCEf7FnxnTC+5pN8L4c9n+CzIt23kWKtV5eo='
WHERE
key_id = 'ef072e53fe157e38f039daa637433363c12870a53b20e5bbec9d8dea1019283d'
AND (
token = 'SkLO/AMNCEf7FnxnTC+5pN8L4c9n+CzIt23kWKtV5eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)