UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdDHeC4pyBbyEUxLhNun/ahM05zu9RfRthPxd0PO7Vs='
WHERE
key_id = '47781f62c26f782ea8076d9acffe0b0f936ee4868aa7eff928918b2802ed33e4'
AND (
token = 'zdDHeC4pyBbyEUxLhNun/ahM05zu9RfRthPxd0PO7Vs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)