UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZ2xN1X2xjKuQDSGIUvgARpysUWT0W1mcy/yq7JsrSg='
WHERE
key_id = '6d0857f5352389d8bfff7fbaa3dc30de223f38a6412aed5cd0286a3429ddc4de'
AND (
token = 'XZ2xN1X2xjKuQDSGIUvgARpysUWT0W1mcy/yq7JsrSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)