UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hv9ph8PQH8mKyRDWVot2hvy0NYrm42JYUr6mroXQbf0='
WHERE
key_id = '016898bd0330acf66549078f745c9b88451d6a7e030237a3227eb71d30fe18a0'
AND (
token = 'hv9ph8PQH8mKyRDWVot2hvy0NYrm42JYUr6mroXQbf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)