UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cANBGXTYHGrBBaypRY6mVGPUPX30LAPgVMBoK0Bhz/8='
WHERE
key_id = 'd36247e4df3e592831614f026a8933354a2d73bf1c481432c766a03d094f7f56'
AND (
token = 'cANBGXTYHGrBBaypRY6mVGPUPX30LAPgVMBoK0Bhz/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)