UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prtYTvk7kOQwHrpYfrsd+xmZLV+VQX3ytAfHXV08uQY='
WHERE
key_id = 'e5b865ce782dc9eda3b831c1f3977af75a76adc7fdc0c1b9500022ab9c3e3a71'
AND (
token = 'prtYTvk7kOQwHrpYfrsd+xmZLV+VQX3ytAfHXV08uQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)