UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qQj56wbNpg9OI3fUZBupAJV5VUK7Ht+tcpmf/5VyW18='
WHERE
key_id = 'bc489548883ea2a660ea7a6b522789175949a3d30e27d9ae226c8264a7340398'
AND (
token = 'qQj56wbNpg9OI3fUZBupAJV5VUK7Ht+tcpmf/5VyW18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)