UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dKm5d17kTuDGxWbtDstb3pfvBM0s06ZJIMTJLi4CIm0='
WHERE
key_id = '1e82c34d79466df16b8d173ac4a0fe8cbf7a206bc851f7adc37533bc519cce2c'
AND (
token = 'dKm5d17kTuDGxWbtDstb3pfvBM0s06ZJIMTJLi4CIm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)