UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fNy6RwDvhtEtHhmIi6MH7jMPQRaUrjxXCRNoPoX2tw='
WHERE
key_id = '1f258744b951319d879d464023475953b09acf7f6796129c36ea96c9085689a4'
AND (
token = '1fNy6RwDvhtEtHhmIi6MH7jMPQRaUrjxXCRNoPoX2tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)