UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8JVZNF1OU4B3sIJWHJkYrIOp7PGWPMUtBPRNl56qF8='
WHERE
key_id = 'd26c4a1e4ae220879a656b5b9615a898403c581ab7aff84b37b749dc54eefb31'
AND (
token = 'C8JVZNF1OU4B3sIJWHJkYrIOp7PGWPMUtBPRNl56qF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)