UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1NmiJWH8kyJeKbkzloq4+VBcQAaYmEG+2dBwMtYyaLo='
WHERE
key_id = '6efcd71865de3dd6cfc8707063029a292fa936560c16326849d2f2586248d556'
AND (
token = '1NmiJWH8kyJeKbkzloq4+VBcQAaYmEG+2dBwMtYyaLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)