UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JrgE9jz5TOAQDoh3VrYXcRUOioXzSRKaoiiDsYpAh8='
WHERE
key_id = '8c6a9d302acaf8c3eb7ce3d66ebdf14d1bf4e90dd345c58ef5b539f41dab4f6d'
AND (
token = '4JrgE9jz5TOAQDoh3VrYXcRUOioXzSRKaoiiDsYpAh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)