UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1dqQ6o6KrfMsJ2fyLdJf7VUqB2PfOR8AjJGfbC4y5hU='
WHERE
key_id = '3f5056695877a8725af3409faeadeeace92aec7e0f330ea56b227721d724b7df'
AND (
token = '1dqQ6o6KrfMsJ2fyLdJf7VUqB2PfOR8AjJGfbC4y5hU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)