UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhZLSGFT7Ba33o1c8BJwThg7lrmbIbWNvstGKGV+TeE='
WHERE
key_id = 'c178b525666773df5d3e3e9aa9f4d3cbf02e5250c336f7cb8ef3ce3541178d2f'
AND (
token = 'ZhZLSGFT7Ba33o1c8BJwThg7lrmbIbWNvstGKGV+TeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)