UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6iyvryO7KWOUc9tP+y9qKXqf0hJi7HnPiUxmMMFXBIQ=' 
WHERE 
  key_id = '8bc6b940f183a2ecddd33babeb2f02656969ffa437fc0084c60c2c2d880caca7' 
  AND (
    token = '6iyvryO7KWOUc9tP+y9qKXqf0hJi7HnPiUxmMMFXBIQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028