UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MQcBpEcA4ViwYbm/oIAvOecxeFTgzktsuyME2ZyqUwA='
WHERE
key_id = '0204a9ca6e4333afb669b347ac6b9b0d040a62811ad2ca0ba1bc944b6e599812'
AND (
token = 'MQcBpEcA4ViwYbm/oIAvOecxeFTgzktsuyME2ZyqUwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)