UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xeWiRD/7gf4wlNCvj2WmK4GyIlansETiAkv6PuB1/g='
WHERE
key_id = 'acd96638971c00514b3e520242f5f7e3ff334a23462b91c2ddbc54e59056f5db'
AND (
token = '6xeWiRD/7gf4wlNCvj2WmK4GyIlansETiAkv6PuB1/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)