UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KsZ0LhatCSm3f+HRBg5Fj+NLJ3UCUrdpJG51ldQECks='
WHERE
key_id = 'd9a4ce32077a6cb27ad61aebabf0166b50a05f1c2c1c7a08f1621c77a225a1bd'
AND (
token = 'KsZ0LhatCSm3f+HRBg5Fj+NLJ3UCUrdpJG51ldQECks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)