UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8qjkhqMmdaZ+hGvRqHwAddiUT9XTfzJrPXC5g/vnvA='
WHERE
key_id = '02a8b0f96eca807827d85b517868ad1f5396cff7440311f58d29acf6017a045e'
AND (
token = '/8qjkhqMmdaZ+hGvRqHwAddiUT9XTfzJrPXC5g/vnvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)